UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4LC0AOH7ya9R7OJ+4IDFYOsfBhZCLaWGcZ6GfCU8h7M='
WHERE
key_id = '26e1a65fa38edfda18d23cea0ef1c40e18f3f234adc6cfb0f15e7f6a5d1a56ea'
AND (
token = '4LC0AOH7ya9R7OJ+4IDFYOsfBhZCLaWGcZ6GfCU8h7M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)