UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rfaPUnl3N7XzlyP4auKTuz5MORg7Y30iPavbKgWG5xg='
WHERE
key_id = 'e835af5f5607afa7b21e171bb7ae589010f8dad5cdf0983ec0686e3d3f3df472'
AND (
token = 'rfaPUnl3N7XzlyP4auKTuz5MORg7Y30iPavbKgWG5xg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)