UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Pf4Kofp6kRvSVWfRJ2GvKBN2ks73J7V+0HFZKkYvpA4='
WHERE
key_id = '8f438796eabb576b23e2b77b2f582816a9da5e73b451253b3c436e6015be41d1'
AND (
token = 'Pf4Kofp6kRvSVWfRJ2GvKBN2ks73J7V+0HFZKkYvpA4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)