UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'I0eJdFpYctoi20FtVR/UMRK+GA7ObwVSAwFdUA9/gsw='
WHERE
key_id = 'a2ba3fc77f2688ccd848412398206f9a76c3e8d7c0a48381c0002f938a48ac7b'
AND (
token = 'I0eJdFpYctoi20FtVR/UMRK+GA7ObwVSAwFdUA9/gsw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)