UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'It7mDxa2OTlKkM8TSStu0HzlzxvmgH9RB5SUvpiWWvc='
WHERE
key_id = '6ab5062b75de59a18a3089cd6262b5270f273998779336f7c4538d99b1e61bb6'
AND (
token = 'It7mDxa2OTlKkM8TSStu0HzlzxvmgH9RB5SUvpiWWvc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)