UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CYcFpCh7sRqPGbyC9USZVgzVcRGQUMkW8a5A1q2MSQc='
WHERE
key_id = '71b3a29448cc359b6e7aa716353cabae51c751c7e18c3cc57110ea9b376e2607'
AND (
token = 'CYcFpCh7sRqPGbyC9USZVgzVcRGQUMkW8a5A1q2MSQc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)