UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/LpWBcgrsrmRmUH5CTm9tJzyNxAjsWtdujKXXTGok1M='
WHERE
key_id = '07cc9de8a4f27089743b06d394596ca529f0328a8076f48400022699f4958f57'
AND (
token = '/LpWBcgrsrmRmUH5CTm9tJzyNxAjsWtdujKXXTGok1M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)