UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'U7n/9p4fBDYBPTVpjfgDZR2jBbIsMvAUe97zPM+ggj0='
WHERE
key_id = 'e71b496bf763525b9965feb8dbd183d1fc20250a34ab20466eaf629d0a53589b'
AND (
token = 'U7n/9p4fBDYBPTVpjfgDZR2jBbIsMvAUe97zPM+ggj0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)