UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zFVN1M8aFcGh4n+hY2XvPJkgl813sn6RH9bxoEsZRNc='
WHERE
key_id = 'be258ab972d409038946011a81af415e9716e99885864a9165bcc45950539cef'
AND (
token = 'zFVN1M8aFcGh4n+hY2XvPJkgl813sn6RH9bxoEsZRNc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)