UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zLn7QaRLtla53Aphsn9juP8D19MHTCLskod4wIMu3go='
WHERE
key_id = 'c6b3ad0371a8d6ea911fbb8bfbe238e682e766101e739e56808160d73261be5a'
AND (
token = 'zLn7QaRLtla53Aphsn9juP8D19MHTCLskod4wIMu3go='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)