UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sE7GCxd+2814ppLYlVdrwgpotX4/+kAgN1qO/ZN6MAA='
WHERE
key_id = 'ca5f2c73337b442f18a0ed77b7f570caac3363ef0cf11363bf263ee2c5ce02a1'
AND (
token = 'sE7GCxd+2814ppLYlVdrwgpotX4/+kAgN1qO/ZN6MAA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)