UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YgGYw4MiufpzUxBhQwGAf+gs6LjKjEd7jKVPkmylohI='
WHERE
key_id = 'a63889545043b09e8b9b1b82268399f4d6e152d5e5536cd1002b245bb2df855b'
AND (
token = 'YgGYw4MiufpzUxBhQwGAf+gs6LjKjEd7jKVPkmylohI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)