UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'g1codiI7UzudC5U97yqdjAhUgsPo78Ka8KM9kUIA9uc='
WHERE
key_id = 'a5d3819fb3b76691b0f8ae314d20ddad0aac5184dcbee921a71765451da6d920'
AND (
token = 'g1codiI7UzudC5U97yqdjAhUgsPo78Ka8KM9kUIA9uc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)