UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'L5HMo3getpe+wyXHI0gGoM63qySSuC9rTn9+7r73eys='
WHERE
key_id = 'dd278a866c5e166f7be825057e6056ab5ef9f4f1134a3b37348f6500f7897aaf'
AND (
token = 'L5HMo3getpe+wyXHI0gGoM63qySSuC9rTn9+7r73eys='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)