UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YcB5q6Pq0X+j3JEmF7F+lxm8EgI1AjMEIcg7Nnf6lt0='
WHERE
key_id = '65f5e93190f18041ab672e8e4d0c4a54642c31f5e88da915266a950d7b64a26a'
AND (
token = 'YcB5q6Pq0X+j3JEmF7F+lxm8EgI1AjMEIcg7Nnf6lt0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)