UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZWRwmklvZCkI/6KCHdl1B9zS3l7laknCwmt+GNi2ayM='
WHERE
key_id = '192e8085c16d38743e3235f8afd03490c7f733934016e66481115ed0c6654373'
AND (
token = 'ZWRwmklvZCkI/6KCHdl1B9zS3l7laknCwmt+GNi2ayM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)