UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XD+JHOKzEb0Y58wYT5LjKB3Hfqsa+pKcCn+P08msVKk='
WHERE
key_id = '3c0e96917a6c5caec0b86c8a456283c399b8330f34e56535c124d143fff3afa4'
AND (
token = 'XD+JHOKzEb0Y58wYT5LjKB3Hfqsa+pKcCn+P08msVKk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)