UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZQ4Tc01PChclczaZbyjgwqECcshb54+QUUMQAz+w1Aw='
WHERE
key_id = 'cc4004d0207e7056c240bfec2144880e8bce24ff9c0f292059d3bd4a9640bd1f'
AND (
token = 'ZQ4Tc01PChclczaZbyjgwqECcshb54+QUUMQAz+w1Aw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)