UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zqgBRPkWoQauW9nWiYFHBizgxzNSrOvG8aa79qI+A+M='
WHERE
key_id = '30e159d9efa1ca8b29ab4acb720fe14fa65a1a1b32b5b3dd31d05710524fe6ca'
AND (
token = 'zqgBRPkWoQauW9nWiYFHBizgxzNSrOvG8aa79qI+A+M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)