UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6UFqd/ZHTKcL/LiIjVB0VLo0mkeVVXkO5vnCW95uW4A='
WHERE
key_id = '77de8173a9aa476982c6849c55931c324546e08e930098426494616476a1349c'
AND (
token = '6UFqd/ZHTKcL/LiIjVB0VLo0mkeVVXkO5vnCW95uW4A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)