UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6UqQcXQuTZWHP5ngakek49JwFLYo0CcFW+6wta1Fhiw='
WHERE
key_id = '2f96953649d8152ce1553d2623596bdbf84f4461fe76714389c3374f66ff70da'
AND (
token = '6UqQcXQuTZWHP5ngakek49JwFLYo0CcFW+6wta1Fhiw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)