UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'j/48flzWXvgcrxHkz9VKLJkQrxhK4wiMvifA9DhbnxE='
WHERE
key_id = '5d99e8d5d23874dbb03ad9e7544a4f05f4c22415e65c327feafac92531ff6400'
AND (
token = 'j/48flzWXvgcrxHkz9VKLJkQrxhK4wiMvifA9DhbnxE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)