UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UgxKd+2S0BM8F9Im/nud24jQ5Z7c2Gt7QoT150k+AkE='
WHERE
key_id = 'c1d35523f5ce282eef8563c39a49cbacb4443917b0d30d3b4c47e641b9ef0950'
AND (
token = 'UgxKd+2S0BM8F9Im/nud24jQ5Z7c2Gt7QoT150k+AkE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)