UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZiMhPwto/paKryn51kBE8oUv7VJPvQBT+EY/9sBHmkU='
WHERE
key_id = 'ae16ecda283a40a6260e0f98727a32653945b310782a061a2607becfedebd4b9'
AND (
token = 'ZiMhPwto/paKryn51kBE8oUv7VJPvQBT+EY/9sBHmkU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)