UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ngsUGlSM/7zkn2LC9WCL1hVwwRpvigOr0j5EYZXIF48='
WHERE
key_id = '8bf71a2ca908af828a8ff81f5788e82f5a4953fc241464e0757324078ec31602'
AND (
token = 'ngsUGlSM/7zkn2LC9WCL1hVwwRpvigOr0j5EYZXIF48='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)