UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'eAY3O9EpkNO45YTQCUGlWZVsZ8YjsyIUET28Oi7jxfQ='
WHERE
key_id = '4b7c20e83f0eb463a1adafcccaa938b3dac6a4fd2588e4a342ab4c428adaa174'
AND (
token = 'eAY3O9EpkNO45YTQCUGlWZVsZ8YjsyIUET28Oi7jxfQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)