UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XSVQjN0e9IRobfaNPNuSqMrHW0UmJXiT9MMBkiaVfx4='
WHERE
key_id = '9c42238e0d1a6d03c295d25532fca5b236a32ab236819463a9e0cc98de9fc1ad'
AND (
token = 'XSVQjN0e9IRobfaNPNuSqMrHW0UmJXiT9MMBkiaVfx4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)