SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'e7cdeb662d0454bbd65072b39d375810b1cc415c5cd91a86c825c9507ee8dbda' 
  AND token = 'Nna6N9ao2hlyenUBSRaDb9CRVIuBEAW8wuZLoh1Fg7w=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00039

JSON explain

{
  "query_block": {
    "select_id": 1,
    "message": "no matching row in const table"
  }
}