UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lAk/0m1t+d41yfAtPpvsV0yHZKvr1fA3t8SU+HGuGWI='
WHERE
key_id = 'c6f51df545aeb23cdf350ec9717a3e7d2548560898d2d946049d6de5a4d11eb1'
AND (
token = 'lAk/0m1t+d41yfAtPpvsV0yHZKvr1fA3t8SU+HGuGWI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)