UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G1hg0TCwB39V+v4arKH2oV30Ftf3FjfeLHciNnp+dUY='
WHERE
key_id = '43b05e7ef77cc25303bfc265341ec22913bc01b7e4d71f183834a47ad9ab621c'
AND (
token = 'G1hg0TCwB39V+v4arKH2oV30Ftf3FjfeLHciNnp+dUY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)