UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'g3LIwl/e2lg0oLs60QoMq/ssPFsJ0kH2wzRdf6odQx8='
WHERE
key_id = '24662097e65df48f36605f1bd46dabdf5e779a00d56eb5597ad317064cf9b053'
AND (
token = 'g3LIwl/e2lg0oLs60QoMq/ssPFsJ0kH2wzRdf6odQx8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)