SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '303251acf755e8dab6f6c5c25865576e2deb3786765d7b76fb5592181d7f0dcd' 
  AND token = '0BUide6UBaXJ14yFsQq9s+tfUpV4oa7kG17Mz4NNE6o=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00018

JSON explain

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