UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Km1pBoynFMUDwNHIL0VCaByn0EsjfngWqdEKqOp9TEA='
WHERE
key_id = '97cfcf22609b3cc7a6847ca6359c3969bd750e74a21aeecf6bc4ebfe26b44e71'
AND (
token = 'Km1pBoynFMUDwNHIL0VCaByn0EsjfngWqdEKqOp9TEA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)