UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'L04xzhLeyLRm0fzCR92R05HD9jy+wLDehE7ye96TmbM='
WHERE
key_id = 'fcaad0a173b051965bec99982a797dc5c1f1e34b6eb6ac62d0cf32abb874bbb9'
AND (
token = 'L04xzhLeyLRm0fzCR92R05HD9jy+wLDehE7ye96TmbM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)