UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XKdnfC5bCGHjkcGNpGzECAEitFi8rCXmZcDR8KD7sPM='
WHERE
key_id = '10776ac3e57dc8c4f508f3e3a72e192dff2a47b8e4e5b76760ea17e68f431ea0'
AND (
token = 'XKdnfC5bCGHjkcGNpGzECAEitFi8rCXmZcDR8KD7sPM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)